﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace sqlsearcher.Models
{
    public class SqlServerKeyWords
    {
        public List<string> GetKeys()
        {
            return new List<string>() {
            "add","except","percent",
            "all", "exec","plan",
            "alter","execute","precision",
            "and","exists","primary",
            "any","exit","print",
            "as","fetch","proc",
            "asc","file","procedure",
            "authorization","fillfactor","public",
            "backup","for","raiserror",
            "begin","foreign","read",
            "between","freetext","readtext",
            "break","freetexttable","reconfigure",
            "browse","from","references",
            "bulk","full","replication",
            "by","function","restore",
            "cascade","goto","restrict",
            "case","grant","return ",
            "check","group","revoke",
            "checkpoint","having","right",
            "close","holdlock","rollback",
            "clustered","identity","rowcount",
            "coalesce","identity_insert","rowguidcol",
            "collate","identitycol","rule",
            "column  if","save",
            "commit","in","schema",
            "compute","index","select",
            "constraint","inner","session_user",
            "contains","insert","set",
            "containstable","intersect","setuser",
            "continue","into","shutdown",
            "convert","is","some",
            "create","join","statistics",
            "cross","key","system_user",
            "current","kill","table",
            "current_date","left","textsize",
            "current_time","like","then",
            "current_timestamp","lineno","to",
            "current_user","load","top",
            "cursor","national","tran",
            "database","nocheck","transaction",
            "dbcc","nonclustered","trigger",
            "deallocate","not","truncate",
            "declare","null","tsequal",
            "default","nullif","union",
            "delete","of","unique",
            "deny","off","update",
            "desc","offsets","updatetext",
            "disk","on","use",
            "distinct","open","user",
            "distributed","opendatasource","values",
            "double","openquery","varying",
            "drop","openrowset","view",
            "dummy","openxml","waitfor",
            "dump","option","when",
            "else ","or","where",
            "end","order","while",
            "errlvl","outer with",
            "escape  over","writetext"
            };
        }
    }
}
